#!/usr/bin/python
# -*- coding: utf-8 -*-
# @version        : 1.0
# @Create Time    : 2022/3/21 17:36
# @File           : sms.py
# @IDE            : PyCharm
# @desc           : 短信发送记录模型

from sqlalchemy.orm import Mapped, mapped_column
from db.db_base import BaseModel
from sqlalchemy import Integer, String


class Inventory(BaseModel):
    __tablename__ = "vadmin_inventory_weigh"
    __table_args__ = ({'comment': '过磅记录'})


    id: Mapped[int] = mapped_column(Integer, comment="操作人",primary_key=True)
    custom: Mapped[str] = mapped_column(String(11), comment="客户名称")
    weigh_id: Mapped[int] = mapped_column(Integer, comment="地磅名称")
    type: Mapped[str] = mapped_column(String(11), comment="品类")
    model: Mapped[str] = mapped_column(String(11), comment="规格")
    warehouse_number: Mapped[int] = mapped_column(Integer, comment="仓号")
    net_weight: Mapped[int] = mapped_column(Integer, comment="净重")
    out_ticket: Mapped[str] = mapped_column(String(11), comment="出厂票号")
    driver: Mapped[str] = mapped_column(String(11), comment="司机")
    car_number: Mapped[str] = mapped_column(String(11), comment="车牌")
    create_datetime: Mapped[str] = mapped_column(String(11), comment="创建时间")
    actual_inventory: Mapped[int] = mapped_column(Integer, comment="实际入库量(吨)")
    notes: Mapped[str] = mapped_column(String(11), comment="备注")